Queries in the Advanced Options 8

Queries to create two  tables - 1. Interviewer    2. Interviewee

you can use below Query for Interviewer:

SELECT   CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewer

FROM     IMockInterviewCritique

WHERE    Interviewer is not null

GROUP BY CB_MID,InterviewDate,Interviewer

you can use below Query for Interviewee:

SELECT   CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewee

FROM     IMockInterviewCritique

WHERE    Interviewee is not null

GROUP BY CB_MID,InterviewDate,Interviewee


Follow the Screenshots and Gif below to create them.







The link is very informative to get the SQL queries into power bi:

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-sql-server-data-in-power-bi-desktop-part-5/

Queries in the Advanced Options 8

Queries to create two  tables - 1. Interviewer    2. Interviewee

you can use below Query for Interviewer:

SELECT   CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewer

FROM     IMockInterviewCritique

WHERE    Interviewer is not null

GROUP BY CB_MID,InterviewDate,Interviewer

you can use below Query for Interviewee:

SELECT   CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewee

FROM     IMockInterviewCritique

WHERE    Interviewee is not null

GROUP BY CB_MID,InterviewDate,Interviewee


Follow the Screenshots and Gif below to create them.







The link is very informative to get the SQL queries into power bi:

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-sql-server-data-in-power-bi-desktop-part-5/